<?php
require("../../inc/header.php");

/*
		SoftName : EmpireBak Version 2010
		Author   : wm_chief
		Copyright: Powered by www.phome.net
*/

DoSetDbChar('utf8');
E_D("DROP TABLE IF EXISTS `ecs_store_inout_list`;");
E_C("CREATE TABLE `ecs_store_inout_list` (
  `rec_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `inout_sn` varchar(255) NOT NULL,
  `inout_status` tinyint(1) unsigned NOT NULL COMMENT '1,退回;2,等待审核;3,审核通过;4,审核拒绝',
  `store_id` int(5) unsigned NOT NULL,
  `adminer_id` smallint(5) unsigned NOT NULL,
  `inout_type` smallint(5) unsigned NOT NULL,
  `inout_mode` tinyint(1) unsigned NOT NULL COMMENT '1：表示出库  2：表示入库',
  `order_id` int(10) unsigned NOT NULL,
  `order_sn` varchar(255) NOT NULL,
  `takegoods_man` varchar(255) NOT NULL,
  `today_sn` smallint(5) unsigned NOT NULL,
  `add_date` int(8) unsigned NOT NULL,
  `add_time` int(10) unsigned NOT NULL,
  `supplier_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '入驻商店铺id',
  `store_type_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '仓库类型id',
  PRIMARY KEY (`rec_id`),
  KEY `supplier_id` (`supplier_id`)
) ENGINE=MyISAM AUTO_INCREMENT=50 DEFAULT CHARSET=utf8 COMMENT='出入库记录'");
E_D("replace into `ecs_store_inout_list` values('1','rk201412120001','3','3','4','4','2','0','','沈阳库库管','1','20141212','1418349643','0','0');");
E_D("replace into `ecs_store_inout_list` values('2','rk201412120002','3','4','7','7','2','0','','yangyue','2','20141212','1418349769','0','0');");
E_D("replace into `ecs_store_inout_list` values('3','rk201412120003','3','4','7','7','2','0','','yangyue','3','20141212','1418350283','0','0');");
E_D("replace into `ecs_store_inout_list` values('4','rk201412120004','3','3','4','7','2','0','','yuxinliang','4','20141212','1418350418','0','0');");
E_D("replace into `ecs_store_inout_list` values('5','ck201412120001','3','4','6','1','1','0','2014121210920','北京库主管','1','20141212','1418351154','0','0');");
E_D("replace into `ecs_store_inout_list` values('6','ck201412120002','3','4','1','1','1','0','2014121215701','admin','2','20141212','1418351489','0','0');");
E_D("replace into `ecs_store_inout_list` values('7','ck201412120003','3','4','7','1','1','0','2014121202491','北京库库管','3','20141212','1418351581','0','0');");
E_D("replace into `ecs_store_inout_list` values('8','ck201412120004','3','4','6','1','1','0','2014121238831','北京库主管','4','20141212','1418351626','0','0');");
E_D("replace into `ecs_store_inout_list` values('9','rk201412120005','3','4','13','7','2','0','','jiangtianhao','5','20141212','1418351711','19','0');");
E_D("replace into `ecs_store_inout_list` values('10','rk201412120006','3','4','13','7','2','0','','jiangtianhao','6','20141212','1418351757','19','0');");
E_D("replace into `ecs_store_inout_list` values('11','ck201412120005','3','4','6','1','1','0','2014121231211','北京库主管','5','20141212','1418352084','0','0');");
E_D("replace into `ecs_store_inout_list` values('12','ck201412120006','3','4','6','1','1','0','2014121231211','北京库主管','6','20141212','1418352084','0','0');");
E_D("replace into `ecs_store_inout_list` values('13','ck201412120007','3','4','6','1','1','0','2014121231211','北京库主管','7','20141212','1418352084','0','0');");
E_D("replace into `ecs_store_inout_list` values('14','ck201412120008','3','4','6','1','1','0','2014121231211','北京库主管','8','20141212','1418352084','0','0');");
E_D("replace into `ecs_store_inout_list` values('15','ck201412120009','3','4','7','1','1','0','2014121255532','北京库库管','9','20141212','1418353042','0','0');");
E_D("replace into `ecs_store_inout_list` values('16','ck201412120010','3','4','1','1','1','0','2014121213708','admin','10','20141212','1418354042','0','0');");
E_D("replace into `ecs_store_inout_list` values('18','rk201412120011','3','8','14','9','2','0','','1','11','20141212','1418354351','18','18');");
E_D("replace into `ecs_store_inout_list` values('19','ck201412120012','3','8','14','1','1','0','','1','12','20141212','1418354485','18','18');");
E_D("replace into `ecs_store_inout_list` values('20','ck201412120013','3','4','1','1','1','0','2014121276997','admin','13','20141212','1418356142','19','0');");
E_D("replace into `ecs_store_inout_list` values('21','ck201412120014','3','4','1','1','1','0','2014121219228','admin','14','20141212','1418363314','19','0');");
E_D("replace into `ecs_store_inout_list` values('22','ck201412120015','3','4','1','1','1','0','2014121220765','admin','15','20141212','1418363673','0','0');");
E_D("replace into `ecs_store_inout_list` values('23','ck201412120016','3','4','1','1','1','0','2014121220765','admin','16','20141212','1418363673','0','0');");
E_D("replace into `ecs_store_inout_list` values('24','rk201412120017','3','3','16','7','2','0','','韩都衣舍时尚旗舰店','17','20141212','1418364311','21','0');");
E_D("replace into `ecs_store_inout_list` values('25','ck201412120017','3','4','7','1','1','0','2014121293172','北京库库管','17','20141212','1418365178','0','0');");
E_D("replace into `ecs_store_inout_list` values('26','ck201412120018','3','3','7','1','1','0','2014121266026','北京库库管','18','20141212','1418367860','21','0');");
E_D("replace into `ecs_store_inout_list` values('27','ck201412120019','3','4','7','1','1','0','2014121204789','北京库库管','19','20141212','1418368069','0','0');");
E_D("replace into `ecs_store_inout_list` values('28','rk201412120020','3','12','19','10','2','0','','yang','20','20141212','1418368710','22','22');");
E_D("replace into `ecs_store_inout_list` values('29','ck201412120021','4','12','19','2','1','0','','yang','21','20141212','1418368821','22','22');");
E_D("replace into `ecs_store_inout_list` values('30','ck201412120022','1','12','19','2','1','0','','yang','22','20141212','1418369042','22','22');");
E_D("replace into `ecs_store_inout_list` values('31','ck201412120023','3','12','19','2','1','0','','yang','23','20141212','1418369187','22','22');");
E_D("replace into `ecs_store_inout_list` values('32','rk201412120024','3','12','19','10','2','0','','yang','24','20141212','1418369794','22','22');");
E_D("replace into `ecs_store_inout_list` values('33','rk201412120025','3','12','19','10','2','0','','yang','25','20141212','1418369826','22','22');");
E_D("replace into `ecs_store_inout_list` values('34','ck201412120026','3','12','19','2','1','0','','yang','26','20141212','1418370384','22','22');");
E_D("replace into `ecs_store_inout_list` values('35','ck201412120027','2','4','16','8','1','0','','韩都衣舍时尚旗舰店','27','20141212','1418370505','21','0');");
E_D("replace into `ecs_store_inout_list` values('36','ck201412120028','1','3','16','8','1','0','','韩都衣舍时尚旗舰店','28','20141212','1418370625','21','0');");
E_D("replace into `ecs_store_inout_list` values('37','ck201412120029','3','3','16','8','1','0','','韩都衣舍时尚旗舰店','29','20141212','1418370677','21','0');");
E_D("replace into `ecs_store_inout_list` values('38','ck201412120030','2','4','16','8','1','0','','韩都衣舍时尚旗舰店','30','20141212','1418371807','21','0');");
E_D("replace into `ecs_store_inout_list` values('39','ck201412120031','3','12','19','1','1','0','2014121248131','68ecshopyy','31','20141212','1418372651','22','22');");
E_D("replace into `ecs_store_inout_list` values('40','rk201412120032','3','12','19','10','2','0','','yang','32','20141212','1418373056','22','22');");
E_D("replace into `ecs_store_inout_list` values('41','ck201412120033','1','4','16','8','1','0','','韩都衣舍时尚旗舰店','33','20141212','1418373978','21','0');");
E_D("replace into `ecs_store_inout_list` values('42','ck201412120034','3','12','19','1','1','0','2014121287343','68ecshopyy','34','20141212','1418374112','22','22');");
E_D("replace into `ecs_store_inout_list` values('43','ck201412120035','3','12','19','1','1','0','2014121271854','68ecshopyy','35','20141212','1418375760','22','22');");
E_D("replace into `ecs_store_inout_list` values('44','ck201412120036','3','12','19','1','1','0','2014121278209','68ecshopyy','36','20141212','1418376916','22','22');");
E_D("replace into `ecs_store_inout_list` values('45','ck201412120037','3','12','19','1','1','0','2014121215678','68ecshopyy','37','20141212','1418377863','22','22');");
E_D("replace into `ecs_store_inout_list` values('46','ck201412120038','3','12','19','1','1','0','2014121263493','68ecshopyy','38','20141212','1418378715','22','22');");
E_D("replace into `ecs_store_inout_list` values('47','rk201412290001','3','0','1','6','2','0','2014121629361','admin','1','20141229','1419831558','0','0');");
E_D("replace into `ecs_store_inout_list` values('48','rk201412290002','3','0','1','6','2','0','2014121620024','admin','2','20141229','1419831607','0','0');");
E_D("replace into `ecs_store_inout_list` values('49','ck201412290001','3','4','7','2','1','0','2014122970731','haha(26)','1','20141229','1419841905','19','0');");

require("../../inc/footer.php");
?>